Re: jdbc

At 10:01 PM -0500 12/27/00, Wayne Davis wrote:
>I'm having trouble getting the postgresql jdbc driver to work. 
>Here's my error:
>java.sql.SQLException: No suitable driver
>        at java.sql.DriverManager.getConnection(DriverManager.java, 
>Compiled Code)
>        at java.sql.DriverManager.getConnection(DriverManager.java, 
>Compiled Code)
>        at DBBean.<init>(DBBean.java, Compiled Code)
>        at DBBean.main(DBBean.java, Compiled Code)


Maybe you had the same naming issue I found (see below).

John DeSoi, Ph.D.


-------
X-From_: desoi@icx.net  Wed Dec 20 10:57:45 2000
X-Sender: desoi@mailhub.icx.net (Unverified)
Date: Wed, 20 Dec 2000 10:55:39 -0500
To: peter@retep.org.uk
From: John DeSoi <desoi@icx.net>
Subject: JDBC documentation error

Hi Peter,


I'm just getting started with postgres and JDBC. I wanted to mention 
a documentation error that might cause considerable pain for other 
newbies like me :)

You have:

In the first method, your code implicitly loads the driver using the 
Class.forName() method. For Postgres, you would use:

Class.forName("postgresql.Driver");


In using this, my application kept crashing (of course it should have 
given me an error message, but for some reason it just crashed). I 
finally got things working by changing it to

Class.forName("org.postgresql.Driver");

Thanks for all your work,

John DeSoi, Ph.D.